    <div id="page-wrapper">

        <div class="row">
          <div class="col-lg-12">
            <h1><?php echo $ssdashboard ?></h1>
            <ol class="breadcrumb">
              <li class="active"><i class="fa fa-dashboard"></i> <?php echo $ssdashboard ?></li>
            </ol>
          </div>
        </div><!-- /.row -->
        <div class="row">
          <div class="col-lg-3">
            <div class="panel panel-info">
              <div class="panel-heading">
                <div class="row">
                  <div class="col-xs-6">
                    <i class="fa fa-comments fa-5x"></i>
                  </div>
                  <div class="col-xs-6 text-right">
                    <p class="announcement-heading">
						<?php 
							$numRows = $dbh->query("SELECT COUNT(*) FROM posts")->fetchColumn();
							echo $numRows; 
                        ?>                    
                    </p>
                    <p class="announcement-text">Total Post</p>
                  </div>
                </div>
              </div>
              <a href="posts">
                <div class="panel-footer announcement-bottom">
                  <div class="row">
                    <div class="col-xs-6">
                      Ver Posts
                    </div>
                    <div class="col-xs-6 text-right">
                      <i class="fa fa-arrow-circle-right"></i>
                    </div>
                  </div>
                </div>
              </a>
            </div>
          </div>
          <div class="col-lg-3">
            <div class="panel panel-warning">
              <div class="panel-heading">
                <div class="row">
                  <div class="col-xs-6">
                    <i class="fa fa-users fa-5x"></i>
                  </div>
                  <div class="col-xs-6 text-right">
                    <p class="announcement-heading">
						<?php 
							$numRows = $dbh->query("SELECT COUNT(*) FROM usuarios")->fetchColumn();
							echo $numRows; 
                        ?>  
                    </p>
                    <p class="announcement-text">Usuários</p>
                  </div>
                </div>
              </div>
              <a href="usuarios">
                <div class="panel-footer announcement-bottom">
                  <div class="row">
                    <div class="col-xs-6">
                      Ver Usuários
                    </div>
                    <div class="col-xs-6 text-right">
                      <i class="fa fa-arrow-circle-right"></i>
                    </div>
                  </div>
                </div>
              </a>
            </div>
          </div>

        </div><!-- /.row -->

		<div class="row">
              <div class="col-lg-12">
                <div class="panel panel-primary">
                  <div class="panel-heading">
                    <h3 class="panel-title"><i class="fa fa-clock-o"></i> Últimos Posts</h3>
                  </div>
                  <div class="panel-body">
                  <?php $sql = 'SELECT * FROM posts ORDER BY data_post DESC LIMIT 6';  foreach ($pdo->query($sql) as $row): ?>
                    <div class="list-group">
                      <a href="posts-edita&id=<?php echo $row['id']?>" class="list-group-item">
                        <span class="badge">Data: <?php echo $row['data_post']; ?></span>
                        <i class="fa fa-indent"></i> <?php echo $row['titulo_post']; ?>
                      </a>
                  </div>
                  <?php endforeach; ?>
                </div>
              </div>
          </div>

      </div><!-- /#page-wrapper -->
    </div><!-- /#wrapper -->